Overview

Dataset statistics

Number of variables	44
Number of observations	87980
Missing cells	88989
Missing cells (%)	2.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	29.5 MiB
Average record size in memory	352.0 B

Variable types

Numeric	16
Text	10
Categorical	14
DateTime	3
Unsupported	1

Alerts

`release_year` has constant value "2006"	Constant
`language_id` has constant value "1"	Constant
`district` has constant value " "	Constant
`language` has constant value "English"	Constant
`actor_id` is highly overall correlated with `film_actor_id`	High correlation
`address_id` is highly overall correlated with `customer_id` and 1 other fields	High correlation
`amount` is highly overall correlated with `rental_rate`	High correlation
`category` is highly overall correlated with `category_id`	High correlation
`category_id` is highly overall correlated with `category`	High correlation
`customer_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`film_actor_id` is highly overall correlated with `actor_id`	High correlation
`film_category_id` is highly overall correlated with `film_id` and 1 other fields	High correlation
`film_id` is highly overall correlated with `film_category_id` and 1 other fields	High correlation
`inventory_id` is highly overall correlated with `film_category_id` and 1 other fields	High correlation
`manager_staff_id` is highly overall correlated with `staff_fn` and 3 other fields	High correlation
`payment_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`rental_rate` is highly overall correlated with `amount`	High correlation
`staff_fn` is highly overall correlated with `manager_staff_id` and 3 other fields	High correlation
`staff_id` is highly overall correlated with `manager_staff_id` and 3 other fields	High correlation
`staff_ln` is highly overall correlated with `manager_staff_id` and 3 other fields	High correlation
`store_id` is highly overall correlated with `manager_staff_id` and 3 other fields	High correlation
`active` is highly imbalanced (82.7%)	Imbalance
`return_date` has 1009 (1.1%) missing values	Missing
`address2` has 87980 (100.0%) missing values	Missing
`address2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2026-01-14 06:38:37.102482
Analysis finished	2026-01-14 06:38:52.035068
Duration	14.93 seconds
Software version	ydata-profiling vv4.18.1
Download configuration	config.json

film_id
Real number (ℝ)

High correlation

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	502.11853

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	48
Q1	255
median	496
Q3	752
95-th percentile	952
Maximum	1000
Range	999
Interquartile range (IQR)	497

Descriptive statistics

Standard deviation	288.32439
Coefficient of variation (CV)	0.57421581
Kurtosis	-1.1870348
Mean	502.11853
Median Absolute Deviation (MAD)	247
Skewness	-0.010455299
Sum	44176388
Variance	83130.956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
489	288	0.3%
892	276	0.3%
880	275	0.3%
249	273	0.3%
649	264	0.3%
301	261	0.3%
764	252	0.3%
418	248	0.3%
369	248	0.3%
414	240	0.3%
Other values (945)	85355	97.0%

Value	Count	Frequency (%)
1	230	0.3%
2	28	< 0.1%
3	60	0.1%
4	115	0.1%
5	60	0.1%
6	147	0.2%
7	75	0.1%
8	72	0.1%
9	108	0.1%
10	184	0.2%

Value	Count	Frequency (%)
1000	93	0.1%
999	85	0.1%
998	54	0.1%
997	30	< 0.1%
996	35	< 0.1%
995	23	< 0.1%
994	78	0.1%
993	180	0.2%
992	56	0.1%
991	64	0.1%

title
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	27
Median length	22
Mean length	14.313969
Min length	8

Characters and Unicode

Total characters	1259343
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BLANKET BEVERLY
2nd row	BLANKET BEVERLY
3rd row	BLANKET BEVERLY
4th row	BLANKET BEVERLY
5th row	FREAKY POCUS

Value	Count	Frequency (%)
heartbreakers	659	0.4%
boondock	655	0.4%
armageddon	647	0.4%
hellfighters	642	0.4%
apollo	625	0.4%
polish	597	0.3%
shakespeare	576	0.3%
desire	568	0.3%
instinct	558	0.3%
love	548	0.3%
Other values (974)	169885	96.5%

Most occurring characters

Value	Count	Frequency (%)
E	124731	9.9%
A	106201	8.4%
R	91933	7.3%
O	88834	7.1%
	87980	7.0%
N	83346	6.6%
I	83028	6.6%
S	78689	6.2%
T	72852	5.8%
L	60358	4.8%
Other values (17)	381391	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1171363	93.0%
Space Separator	87980	7.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	124731	10.6%
A	106201	9.1%
R	91933	7.8%
O	88834	7.6%
N	83346	7.1%
I	83028	7.1%
S	78689	6.7%
T	72852	6.2%
L	60358	5.2%
C	47904	4.1%
Other values (16)	333487	28.5%

Space Separator

Value	Count	Frequency (%)
	87980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1171363	93.0%
Common	87980	7.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	124731	10.6%
A	106201	9.1%
R	91933	7.8%
O	88834	7.6%
N	83346	7.1%
I	83028	7.1%
S	78689	6.7%
T	72852	6.2%
L	60358	5.2%
C	47904	4.1%
Other values (16)	333487	28.5%

Common

Value	Count	Frequency (%)
	87980	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1259343	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	124731	9.9%
A	106201	8.4%
R	91933	7.3%
O	88834	7.1%
	87980	7.0%
N	83346	6.6%
I	83028	6.6%
S	78689	6.2%
T	72852	5.8%
L	60358	4.8%
Other values (17)	381391	30.3%

description
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	130
Median length	115
Mean length	94.309241
Min length	70

Characters and Unicode

Total characters	8297327
Distinct characters	52
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
2nd row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
3rd row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
4th row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
5th row	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico

Value	Count	Frequency (%)
a	388545	24.0%
of	91030	5.6%
and	87980	5.4%
who	87980	5.4%
must	87980	5.4%
in	87980	5.4%
the	16917	1.0%
mad	15834	1.0%
shark	10679	0.7%
boat	10371	0.6%
Other values (139)	731635	45.2%

Most occurring characters

Value	Count	Frequency (%)
	1528951	18.4%
a	727326	8.8%
n	571906	6.9%
o	508316	6.1%
e	496071	6.0%
t	473278	5.7%
i	420949	5.1%
r	339771	4.1%
s	298832	3.6%
A	286028	3.4%
Other values (42)	2645899	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5722202	69.0%
Space Separator	1528951	18.4%
Uppercase Letter	1029104	12.4%
Dash Punctuation	17070	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	727326	12.7%
n	571906	10.0%
o	508316	8.9%
e	496071	8.7%
t	473278	8.3%
i	420949	7.4%
r	339771	5.9%
s	298832	5.2%
u	272387	4.8%
h	208522	3.6%
Other values (16)	1404844	24.6%

Uppercase Letter

Value	Count	Frequency (%)
A	286028	27.8%
S	102821	10.0%
C	85129	8.3%
M	69641	6.8%
D	61483	6.0%
B	59350	5.8%
T	57431	5.6%
F	56860	5.5%
P	46769	4.5%
W	32959	3.2%
Other values (14)	170633	16.6%

Space Separator

Value	Count	Frequency (%)
	1528951	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	17070	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6751306	81.4%
Common	1546021	18.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	727326	10.8%
n	571906	8.5%
o	508316	7.5%
e	496071	7.3%
t	473278	7.0%
i	420949	6.2%
r	339771	5.0%
s	298832	4.4%
A	286028	4.2%
u	272387	4.0%
Other values (40)	2356442	34.9%

Common

Value	Count	Frequency (%)
	1528951	98.9%
-	17070	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8297327	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1528951	18.4%
a	727326	8.8%
n	571906	6.9%
o	508316	6.1%
e	496071	6.0%
t	473278	5.7%
i	420949	5.1%
r	339771	4.1%
s	298832	3.6%
A	286028	3.4%
Other values (42)	2645899	31.9%

release_year
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

2006	87980

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	351920
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2006
2nd row	2006
3rd row	2006
4th row	2006
5th row	2006

Common Values

Value	Count	Frequency (%)
2006	87980	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2006	87980	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	175960	50.0%
2	87980	25.0%
6	87980	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	351920	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	175960	50.0%
2	87980	25.0%
6	87980	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	351920	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	175960	50.0%
2	87980	25.0%
6	87980	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	351920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	175960	50.0%
2	87980	25.0%
6	87980	25.0%

language_id
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

1	87980

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	87980	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	87980	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	87980	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	87980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	87980	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	87980	100.0%

rental_duration
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

6	19279
4	18643
3	18208
5	17551
7	14299

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7
2nd row	7
3rd row	7
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

Most occurring characters

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18208	20.7%
5	17551	19.9%
7	14299	16.3%

rental_rate
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

0.99	31130
2.99	28943
4.99	27907

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	351920
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.99
2nd row	2.99
3rd row	2.99
4th row	2.99
5th row	2.99

Common Values

Value	Count	Frequency (%)
0.99	31130	35.4%
2.99	28943	32.9%
4.99	27907	31.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.99	31130	35.4%
2.99	28943	32.9%
4.99	27907	31.7%

Most occurring characters

Value	Count	Frequency (%)
9	175960	50.0%
.	87980	25.0%
0	31130	8.8%
2	28943	8.2%
4	27907	7.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	263940	75.0%
Other Punctuation	87980	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	175960	66.7%
0	31130	11.8%
2	28943	11.0%
4	27907	10.6%

Other Punctuation

Value	Count	Frequency (%)
.	87980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	351920	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	175960	50.0%
.	87980	25.0%
0	31130	8.8%
2	28943	8.2%
4	27907	7.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	351920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	175960	50.0%
.	87980	25.0%
0	31130	8.8%
2	28943	8.2%
4	27907	7.9%

length
Real number (ℝ)

Distinct	140
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.10414

Minimum	46
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	46
5-th percentile	52
Q1	80
median	114
Q3	150
95-th percentile	178
Maximum	185
Range	139
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	40.499913
Coefficient of variation (CV)	0.35185454
Kurtosis	-1.197223
Mean	115.10414
Median Absolute Deviation (MAD)	35
Skewness	0.02742301
Sum	10126862
Variance	1640.2429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	1495	1.7%
112	1358	1.5%
178	1355	1.5%
84	1178	1.3%
80	1072	1.2%
63	1070	1.2%
75	1056	1.2%
92	1041	1.2%
179	1019	1.2%
161	1008	1.1%
Other values (130)	76328	86.8%

Value	Count	Frequency (%)
46	585	0.7%
47	732	0.8%
48	832	0.9%
49	369	0.4%
50	563	0.6%
51	647	0.7%
52	704	0.8%
53	759	0.9%
54	524	0.6%
55	336	0.4%

Value	Count	Frequency (%)
185	936	1.1%
184	393	0.4%
183	417	0.5%
182	252	0.3%
181	837	1.0%
180	376	0.4%
179	1019	1.2%
178	1355	1.5%
177	660	0.8%
176	893	1.0%

replacement_cost
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.190762

Minimum	9.99
Maximum	29.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	9.99
5-th percentile	10.99
Q1	14.99
median	20.99
Q3	24.99
95-th percentile	29.99
Maximum	29.99
Range	20
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.0882873
Coefficient of variation (CV)	0.30153827
Kurtosis	-1.2239788
Mean	20.190762
Median Absolute Deviation (MAD)	6
Skewness	-0.0352181
Sum	1776383.2
Variance	37.067243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
22.99	5626	6.4%
27.99	5215	5.9%
12.99	5024	5.7%
14.99	4893	5.6%
21.99	4886	5.6%
29.99	4686	5.3%
20.99	4672	5.3%
26.99	4264	4.8%
13.99	4213	4.8%
11.99	4167	4.7%
Other values (11)	40334	45.8%

Value	Count	Frequency (%)
9.99	3924	4.5%
10.99	3526	4.0%
11.99	4167	4.7%
12.99	5024	5.7%
13.99	4213	4.8%
14.99	4893	5.6%
15.99	3141	3.6%
16.99	3593	4.1%
17.99	3748	4.3%
18.99	3744	4.3%

Value	Count	Frequency (%)
29.99	4686	5.3%
28.99	4080	4.6%
27.99	5215	5.9%
26.99	4264	4.8%
25.99	3727	4.2%
24.99	3431	3.9%
23.99	3870	4.4%
22.99	5626	6.4%
21.99	4886	5.6%
20.99	4672	5.3%

rating
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

PG-13	19065
PG	18635
NC-17	17630
R	17210
G	15440

Length

Max length	5
Median length	2
Mean length	2.8801432
Min length	1

Characters and Unicode

Total characters	253395
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	G
2nd row	G
3rd row	G
4th row	G
5th row	R

Common Values

Value	Count	Frequency (%)
PG-13	19065	21.7%
PG	18635	21.2%
NC-17	17630	20.0%
R	17210	19.6%
G	15440	17.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pg-13	19065	21.7%
pg	18635	21.2%
nc-17	17630	20.0%
r	17210	19.6%
g	15440	17.5%

Most occurring characters

Value	Count	Frequency (%)
G	53140	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	143310	56.6%
Decimal Number	73390	29.0%
Dash Punctuation	36695	14.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	53140	37.1%
P	37700	26.3%
N	17630	12.3%
C	17630	12.3%
R	17210	12.0%

Decimal Number

Value	Count	Frequency (%)
1	36695	50.0%
3	19065	26.0%
7	17630	24.0%

Dash Punctuation

Value	Count	Frequency (%)
-	36695	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	143310	56.6%
Common	110085	43.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	53140	37.1%
P	37700	26.3%
N	17630	12.3%
C	17630	12.3%
R	17210	12.0%

Common

Value	Count	Frequency (%)
-	36695	33.3%
1	36695	33.3%
3	19065	17.3%
7	17630	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	253395	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	53140	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

actor_id
Real number (ℝ)

High correlation

Distinct	200
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.9536

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	52
median	102
Q3	149
95-th percentile	191
Maximum	200
Range	199
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	56.900302
Coefficient of variation (CV)	0.56362824
Kurtosis	-1.1747542
Mean	100.9536
Median Absolute Deviation (MAD)	48
Skewness	0.0020452118
Sum	8881898
Variance	3237.6443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	753	0.9%
181	678	0.8%
198	674	0.8%
144	654	0.7%
102	640	0.7%
60	612	0.7%
150	611	0.7%
37	605	0.7%
23	604	0.7%
90	599	0.7%
Other values (190)	81550	92.7%

Value	Count	Frequency (%)
1	305	0.3%
2	387	0.4%
3	311	0.4%
4	274	0.3%
5	496	0.6%
6	279	0.3%
7	479	0.5%
8	317	0.4%
9	381	0.4%
10	362	0.4%

Value	Count	Frequency (%)
200	346	0.4%
199	255	0.3%
198	674	0.8%
197	553	0.6%
196	450	0.5%
195	450	0.5%
194	380	0.4%
193	444	0.5%
192	458	0.5%
191	523	0.6%

actor_fn
Text

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	11
Median length	8
Mean length	5.3013185
Min length	2

Characters and Unicode

Total characters	466410
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FRED
2nd row	ALAN
3rd row	BURT
4th row	THORA
5th row	TOM

Value	Count	Frequency (%)
penelope	1661	1.9%
kenneth	1643	1.9%
jayne	1565	1.8%
matthew	1518	1.7%
julia	1435	1.6%
groucho	1350	1.5%
morgan	1340	1.5%
ed	1310	1.5%
burt	1304	1.5%
christian	1286	1.5%
Other values (118)	73568	83.6%

Most occurring characters

Value	Count	Frequency (%)
E	65221	14.0%
A	52730	11.3%
R	41082	8.8%
N	40749	8.7%
L	29589	6.3%
I	29424	6.3%
O	18594	4.0%
S	18574	4.0%
T	18148	3.9%
M	17206	3.7%
Other values (14)	135093	29.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	466410	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	65221	14.0%
A	52730	11.3%
R	41082	8.8%
N	40749	8.7%
L	29589	6.3%
I	29424	6.3%
O	18594	4.0%
S	18574	4.0%
T	18148	3.9%
M	17206	3.7%
Other values (14)	135093	29.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	466410	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	65221	14.0%
A	52730	11.3%
R	41082	8.8%
N	40749	8.7%
L	29589	6.3%
I	29424	6.3%
O	18594	4.0%
S	18574	4.0%
T	18148	3.9%
M	17206	3.7%
Other values (14)	135093	29.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	466410	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	65221	14.0%
A	52730	11.3%
R	41082	8.8%
N	40749	8.7%
L	29589	6.3%
I	29424	6.3%
O	18594	4.0%
S	18574	4.0%
T	18148	3.9%
M	17206	3.7%
Other values (14)	135093	29.0%

actor_ln
Text

Distinct	121
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	12
Median length	9
Mean length	6.2452489
Min length	3

Characters and Unicode

Total characters	549457
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COSTNER
2nd row	DREYFUSS
3rd row	TEMPLE
4th row	TEMPLE
5th row	MIRANDA

Value	Count	Frequency (%)
kilmer	2145	2.4%
nolte	2119	2.4%
temple	1778	2.0%
degeneres	1611	1.8%
keitel	1586	1.8%
berry	1480	1.7%
torn	1478	1.7%
hoffman	1455	1.7%
guiness	1425	1.6%
garland	1394	1.6%
Other values (111)	71509	81.3%

Most occurring characters

Value	Count	Frequency (%)
E	68603	12.5%
N	44874	8.2%
R	41113	7.5%
A	39729	7.2%
O	39689	7.2%
L	39441	7.2%
I	33954	6.2%
S	32294	5.9%
T	23663	4.3%
D	21500	3.9%
Other values (17)	164597	30.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	548971	99.9%
Dash Punctuation	486	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	68603	12.5%
N	44874	8.2%
R	41113	7.5%
A	39729	7.2%
O	39689	7.2%
L	39441	7.2%
I	33954	6.2%
S	32294	5.9%
T	23663	4.3%
D	21500	3.9%
Other values (16)	164111	29.9%

Dash Punctuation

Value	Count	Frequency (%)
-	486	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	548971	99.9%
Common	486	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	68603	12.5%
N	44874	8.2%
R	41113	7.5%
A	39729	7.2%
O	39689	7.2%
L	39441	7.2%
I	33954	6.2%
S	32294	5.9%
T	23663	4.3%
D	21500	3.9%
Other values (16)	164111	29.9%

Common

Value	Count	Frequency (%)
-	486	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	549457	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	68603	12.5%
N	44874	8.2%
R	41113	7.5%
A	39729	7.2%
O	39689	7.2%
L	39441	7.2%
I	33954	6.2%
S	32294	5.9%
T	23663	4.3%
D	21500	3.9%
Other values (17)	164597	30.0%

customer_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	297.18662

Minimum	1
Maximum	599
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	148
median	296
Q3	446
95-th percentile	568
Maximum	599
Range	598
Interquartile range (IQR)	298

Descriptive statistics

Standard deviation	172.25283
Coefficient of variation (CV)	0.57961164
Kurtosis	-1.1882855
Mean	297.18662
Median Absolute Deviation (MAD)	149
Skewness	0.0085538465
Sum	26146479
Variance	29671.036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
148	272	0.3%
526	251	0.3%
197	244	0.3%
144	239	0.3%
236	233	0.3%
75	233	0.3%
29	223	0.3%
257	221	0.3%
178	220	0.3%
410	216	0.2%
Other values (589)	85628	97.3%

Value	Count	Frequency (%)
1	156	0.2%
2	175	0.2%
3	144	0.2%
4	121	0.1%
5	183	0.2%
6	171	0.2%
7	191	0.2%
8	152	0.2%
9	129	0.1%
10	123	0.1%

Value	Count	Frequency (%)
599	102	0.1%
598	102	0.1%
597	144	0.2%
596	158	0.2%
595	141	0.2%
594	141	0.2%
593	129	0.1%
592	145	0.2%
591	120	0.1%
590	134	0.2%

cust_fn
Text

Distinct	591
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	11
Median length	10
Mean length	5.6729484
Min length	2

Characters and Unicode

Total characters	499106
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHARLOTTE
2nd row	CHARLOTTE
3rd row	CHARLOTTE
4th row	CHARLOTTE
5th row	TOMMY

Value	Count	Frequency (%)
marion	388	0.4%
leslie	325	0.4%
tracy	303	0.3%
terry	291	0.3%
willie	291	0.3%
jessie	290	0.3%
jamie	277	0.3%
eleanor	272	0.3%
kelly	272	0.3%
karl	251	0.3%
Other values (581)	85020	96.6%

Most occurring characters

Value	Count	Frequency (%)
E	62884	12.6%
A	61284	12.3%
R	47045	9.4%
N	42774	8.6%
I	38750	7.8%
L	36712	7.4%
O	23409	4.7%
T	21484	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126263	25.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	499106	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	62884	12.6%
A	61284	12.3%
R	47045	9.4%
N	42774	8.6%
I	38750	7.8%
L	36712	7.4%
O	23409	4.7%
T	21484	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126263	25.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	499106	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	62884	12.6%
A	61284	12.3%
R	47045	9.4%
N	42774	8.6%
I	38750	7.8%
L	36712	7.4%
O	23409	4.7%
T	21484	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126263	25.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	499106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	62884	12.6%
A	61284	12.3%
R	47045	9.4%
N	42774	8.6%
I	38750	7.8%
L	36712	7.4%
O	23409	4.7%
T	21484	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126263	25.3%

cust_ln
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	12
Median length	10
Mean length	6.1921459
Min length	2

Characters and Unicode

Total characters	544785
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HUNTER
2nd row	HUNTER
3rd row	HUNTER
4th row	HUNTER
5th row	COLLAZO

Value	Count	Frequency (%)
hunt	272	0.3%
seal	251	0.3%
peters	244	0.3%
shaw	239	0.3%
dean	233	0.3%
sanders	233	0.3%
hernandez	223	0.3%
douglas	221	0.3%
snyder	220	0.3%
irby	216	0.2%
Other values (589)	85628	97.3%

Most occurring characters

Value	Count	Frequency (%)
E	58265	10.7%
R	54380	10.0%
A	47359	8.7%
N	43534	8.0%
O	38957	7.2%
L	38567	7.1%
S	35961	6.6%
I	26872	4.9%
T	26008	4.8%
H	20076	3.7%
Other values (16)	154806	28.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	544785	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	58265	10.7%
R	54380	10.0%
A	47359	8.7%
N	43534	8.0%
O	38957	7.2%
L	38567	7.1%
S	35961	6.6%
I	26872	4.9%
T	26008	4.8%
H	20076	3.7%
Other values (16)	154806	28.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	544785	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	58265	10.7%
R	54380	10.0%
A	47359	8.7%
N	43534	8.0%
O	38957	7.2%
L	38567	7.1%
S	35961	6.6%
I	26872	4.9%
T	26008	4.8%
H	20076	3.7%
Other values (16)	154806	28.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	544785	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	58265	10.7%
R	54380	10.0%
A	47359	8.7%
N	43534	8.0%
O	38957	7.2%
L	38567	7.1%
S	35961	6.6%
I	26872	4.9%
T	26008	4.8%
H	20076	3.7%
Other values (16)	154806	28.4%

email
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	40
Median length	38
Mean length	31.865094
Min length	26

Characters and Unicode

Total characters	2803491
Distinct characters	41
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHARLOTTE.HUNTER@sakilacustomer.org
2nd row	CHARLOTTE.HUNTER@sakilacustomer.org
3rd row	CHARLOTTE.HUNTER@sakilacustomer.org
4th row	CHARLOTTE.HUNTER@sakilacustomer.org
5th row	TOMMY.COLLAZO@sakilacustomer.org

Value	Count	Frequency (%)
eleanor.hunt@sakilacustomer.org	272	0.3%
karl.seal@sakilacustomer.org	251	0.3%
sue.peters@sakilacustomer.org	244	0.3%
clara.shaw@sakilacustomer.org	239	0.3%
marcia.dean@sakilacustomer.org	233	0.3%
tammy.sanders@sakilacustomer.org	233	0.3%
angela.hernandez@sakilacustomer.org	223	0.3%
marsha.douglas@sakilacustomer.org	221	0.3%
marion.snyder@sakilacustomer.org	220	0.3%
curtis.irby@sakilacustomer.org	216	0.2%
Other values (589)	85628	97.3%

Most occurring characters

Value	Count	Frequency (%)
r	175960	6.3%
.	175960	6.3%
o	175960	6.3%
s	175960	6.3%
a	175960	6.3%
E	121149	4.3%
A	108643	3.9%
R	101425	3.6%
l	87980	3.1%
g	87980	3.1%
Other values (31)	1416514	50.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1495660	53.3%
Uppercase Letter	1043891	37.2%
Other Punctuation	263940	9.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	121149	11.6%
A	108643	10.4%
R	101425	9.7%
N	86308	8.3%
L	75279	7.2%
I	65622	6.3%
O	62366	6.0%
S	55575	5.3%
T	47492	4.5%
C	36337	3.5%
Other values (16)	283695	27.2%

Lowercase Letter

Value	Count	Frequency (%)
r	175960	11.8%
o	175960	11.8%
s	175960	11.8%
a	175960	11.8%
l	87980	5.9%
g	87980	5.9%
e	87980	5.9%
t	87980	5.9%
u	87980	5.9%
c	87980	5.9%
Other values (3)	263940	17.6%

Other Punctuation

Value	Count	Frequency (%)
.	175960	66.7%
@	87980	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2539551	90.6%
Common	263940	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	175960	6.9%
o	175960	6.9%
s	175960	6.9%
a	175960	6.9%
E	121149	4.8%
A	108643	4.3%
R	101425	4.0%
l	87980	3.5%
g	87980	3.5%
e	87980	3.5%
Other values (29)	1240554	48.8%

Common

Value	Count	Frequency (%)
.	175960	66.7%
@	87980	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2803491	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	175960	6.3%
.	175960	6.3%
o	175960	6.3%
s	175960	6.3%
a	175960	6.3%
E	121149	4.3%
A	108643	3.9%
R	101425	3.6%
l	87980	3.1%
g	87980	3.1%
Other values (31)	1416514	50.5%

active
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

1	85714
0	2266

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

Most occurring characters

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	85714	97.4%
0	2266	2.6%

rental_id
Real number (ℝ)

Distinct	16004
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8034.5767

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	820
Q1	4030.75
median	8041.5
Q3	12027.25
95-th percentile	15247.05
Maximum	16049
Range	16048
Interquartile range (IQR)	7996.5

Descriptive statistics

Standard deviation	4630.5566
Coefficient of variation (CV)	0.57632863
Kurtosis	-1.2005905
Mean	8034.5767
Median Absolute Deviation (MAD)	4000.5
Skewness	-0.0012045241
Sum	7.0688206 × 10⁸
Variance	21442055
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4845	15	< 0.1%
5221	15	< 0.1%
7446	15	< 0.1%
14200	15	< 0.1%
7152	15	< 0.1%
12701	15	< 0.1%
15187	15	< 0.1%
2796	15	< 0.1%
5930	15	< 0.1%
8014	15	< 0.1%
Other values (15994)	87830	99.8%

Value	Count	Frequency (%)
1	4	< 0.1%
2	5	< 0.1%
3	2	< 0.1%
4	4	< 0.1%
5	8	< 0.1%
6	4	< 0.1%
7	6	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
10	7	< 0.1%

Value	Count	Frequency (%)
16049	6	< 0.1%
16048	2	< 0.1%
16047	7	< 0.1%
16046	5	< 0.1%
16045	5	< 0.1%
16044	5	< 0.1%
16043	7	< 0.1%
16042	3	< 0.1%
16041	6	< 0.1%
16040	8	< 0.1%

rental_date
Date

Distinct	15776
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Minimum	2005-05-24 22:53:30
Maximum	2006-02-14 15:16:03
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

return_date
Date

Missing

Distinct	15796
Distinct (%)	18.2%
Missing	1009
Missing (%)	1.1%
Memory size	687.5 KiB

Minimum	2005-05-25 23:55:21
Maximum	2005-09-02 02:35:22
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

payment_id
Real number (ℝ)

High correlation

Distinct	16004
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8025.7845

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	796
Q1	4037
median	8032
Q3	12028
95-th percentile	15217
Maximum	16049
Range	16048
Interquartile range (IQR)	7991

Descriptive statistics

Standard deviation	4627.488
Coefficient of variation (CV)	0.57657765
Kurtosis	-1.1977116
Mean	8025.7845
Median Absolute Deviation (MAD)	3995
Skewness	-0.0063754037
Sum	7.0610852 × 10⁸
Variance	21413645
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14839	15	< 0.1%
2280	15	< 0.1%
13129	15	< 0.1%
9457	15	< 0.1%
10004	15	< 0.1%
13202	15	< 0.1%
12463	15	< 0.1%
5662	15	< 0.1%
6853	15	< 0.1%
288	15	< 0.1%
Other values (15994)	87830	99.8%

Value	Count	Frequency (%)
1	4	< 0.1%
2	5	< 0.1%
3	1	< 0.1%
4	3	< 0.1%
5	1	< 0.1%
6	6	< 0.1%
7	4	< 0.1%
8	6	< 0.1%
9	5	< 0.1%
10	5	< 0.1%

Value	Count	Frequency (%)
16049	4	< 0.1%
16048	8	< 0.1%
16047	5	< 0.1%
16046	4	< 0.1%
16045	3	< 0.1%
16044	5	< 0.1%
16043	3	< 0.1%
16042	5	< 0.1%
16041	9	< 0.1%
16040	6	< 0.1%

amount
Real number (ℝ)

High correlation

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1777571

Minimum	0
Maximum	11.99
Zeros	133
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.99
Q1	2.99
median	3.99
Q3	4.99
95-th percentile	8.99
Maximum	11.99
Range	11.99
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.3455906
Coefficient of variation (CV)	0.56144734
Kurtosis	-0.24036645
Mean	4.1777571
Median Absolute Deviation (MAD)	1
Skewness	0.46814077
Sum	367559.07
Variance	5.5017954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
4.99	20434	23.2%
2.99	19873	22.6%
0.99	16264	18.5%
5.99	7181	8.2%
3.99	6350	7.2%
6.99	5929	6.7%
7.99	3654	4.2%
1.99	3490	4.0%
8.99	2633	3.0%
9.99	1302	1.5%
Other values (9)	870	1.0%

Value	Count	Frequency (%)
0	133	0.2%
0.99	16264	18.5%
1.98	4	< 0.1%
1.99	3490	4.0%
2.99	19873	22.6%
3.98	43	< 0.1%
3.99	6350	7.2%
4.99	20434	23.2%
5.98	47	0.1%
5.99	7181	8.2%

Value	Count	Frequency (%)
11.99	49	0.1%
10.99	549	0.6%
9.99	1302	1.5%
9.98	6	< 0.1%
8.99	2633	3.0%
8.97	7	< 0.1%
7.99	3654	4.2%
7.98	32	< 0.1%
6.99	5929	6.7%
5.99	7181	8.2%

payment_date
Date

Distinct	15776
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Minimum	2005-05-24 22:53:30
Maximum	2006-02-14 15:16:03
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

inventory_id
Real number (ℝ)

High correlation

Distinct	4567
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2296.5277

Minimum	1
Maximum	4581
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	213.95
Q1	1158
median	2287
Q3	3428
95-th percentile	4367
Maximum	4581
Range	4580
Interquartile range (IQR)	2270

Descriptive statistics

Standard deviation	1321.2774
Coefficient of variation (CV)	0.575337
Kurtosis	-1.1818466
Mean	2296.5277
Median Absolute Deviation (MAD)	1134
Skewness	-0.0063442828
Sum	2.0204851 × 10⁸
Variance	1745773.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1122	65	0.1%
1123	65	0.1%
158	60	0.1%
2337	60	0.1%
4095	60	0.1%
2424	60	0.1%
2371	60	0.1%
1899	60	0.1%
2423	60	0.1%
2962	55	0.1%
Other values (4557)	87375	99.3%

Value	Count	Frequency (%)
1	30	< 0.1%
2	50	0.1%
3	20	< 0.1%
4	20	< 0.1%
6	50	0.1%
7	40	< 0.1%
8	20	< 0.1%
9	8	< 0.1%
10	12	< 0.1%
11	8	< 0.1%

Value	Count	Frequency (%)
4581	15	< 0.1%
4580	6	< 0.1%
4579	15	< 0.1%
4578	9	< 0.1%
4577	15	< 0.1%
4576	12	< 0.1%
4575	12	< 0.1%
4574	9	< 0.1%
4573	25	< 0.1%
4572	20	< 0.1%

store_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

1	47953
2	40027

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

manager_staff_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

1	47953
2	40027

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

staff_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

1	47953
2	40027

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	87980	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	47953	54.5%
2	40027	45.5%

staff_fn
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Mike	47953
Jon	40027

Length

Max length	4
Median length	4
Mean length	3.5450443
Min length	3

Characters and Unicode

Total characters	311893
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mike
2nd row	Mike
3rd row	Mike
4th row	Mike
5th row	Mike

Common Values

Value	Count	Frequency (%)
Mike	47953	54.5%
Jon	40027	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mike	47953	54.5%
jon	40027	45.5%

Most occurring characters

Value	Count	Frequency (%)
M	47953	15.4%
i	47953	15.4%
k	47953	15.4%
e	47953	15.4%
J	40027	12.8%
o	40027	12.8%
n	40027	12.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	223913	71.8%
Uppercase Letter	87980	28.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	47953	21.4%
k	47953	21.4%
e	47953	21.4%
o	40027	17.9%
n	40027	17.9%

Uppercase Letter

Value	Count	Frequency (%)
M	47953	54.5%
J	40027	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	311893	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	47953	15.4%
i	47953	15.4%
k	47953	15.4%
e	47953	15.4%
J	40027	12.8%
o	40027	12.8%
n	40027	12.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	311893	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	47953	15.4%
i	47953	15.4%
k	47953	15.4%
e	47953	15.4%
J	40027	12.8%
o	40027	12.8%
n	40027	12.8%

staff_ln
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Hillyer	47953
Stephens	40027

Length

Max length	8
Median length	7
Mean length	7.4549557
Min length	7

Characters and Unicode

Total characters	655887
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hillyer
2nd row	Hillyer
3rd row	Hillyer
4th row	Hillyer
5th row	Hillyer

Common Values

Value	Count	Frequency (%)
Hillyer	47953	54.5%
Stephens	40027	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hillyer	47953	54.5%
stephens	40027	45.5%

Most occurring characters

Value	Count	Frequency (%)
e	128007	19.5%
l	95906	14.6%
H	47953	7.3%
i	47953	7.3%
y	47953	7.3%
r	47953	7.3%
S	40027	6.1%
t	40027	6.1%
p	40027	6.1%
h	40027	6.1%
Other values (2)	80054	12.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	567907	86.6%
Uppercase Letter	87980	13.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	128007	22.5%
l	95906	16.9%
i	47953	8.4%
y	47953	8.4%
r	47953	8.4%
t	40027	7.0%
p	40027	7.0%
h	40027	7.0%
n	40027	7.0%
s	40027	7.0%

Uppercase Letter

Value	Count	Frequency (%)
H	47953	54.5%
S	40027	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	655887	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	128007	19.5%
l	95906	14.6%
H	47953	7.3%
i	47953	7.3%
y	47953	7.3%
r	47953	7.3%
S	40027	6.1%
t	40027	6.1%
p	40027	6.1%
h	40027	6.1%
Other values (2)	80054	12.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	655887	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	128007	19.5%
l	95906	14.6%
H	47953	7.3%
i	47953	7.3%
y	47953	7.3%
r	47953	7.3%
S	40027	6.1%
t	40027	6.1%
p	40027	6.1%
h	40027	6.1%
Other values (2)	80054	12.2%

address_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	301.90181

Minimum	5
Maximum	605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	5
5-th percentile	33
Q1	152
median	301
Q3	451
95-th percentile	574
Maximum	605
Range	600
Interquartile range (IQR)	299

Descriptive statistics

Standard deviation	172.88345
Coefficient of variation (CV)	0.57264794
Kurtosis	-1.188535
Mean	301.90181
Median Absolute Deviation (MAD)	149
Skewness	0.010253583
Sum	26561321
Variance	29888.687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
152	272	0.3%
532	251	0.3%
201	244	0.3%
148	239	0.3%
240	233	0.3%
79	233	0.3%
33	223	0.3%
262	221	0.3%
182	220	0.3%
415	216	0.2%
Other values (589)	85628	97.3%

Value	Count	Frequency (%)
5	156	0.2%
6	175	0.2%
7	144	0.2%
8	121	0.1%
9	183	0.2%
10	171	0.2%
11	191	0.2%
12	152	0.2%
13	129	0.1%
14	123	0.1%

Value	Count	Frequency (%)
605	102	0.1%
604	102	0.1%
603	144	0.2%
602	158	0.2%
601	141	0.2%
600	141	0.2%
599	129	0.1%
598	145	0.2%
597	120	0.1%
596	134	0.2%

address
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	38
Median length	34
Mean length	19.461798
Min length	9

Characters and Unicode

Total characters	1712249
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	758 Junan Lane
2nd row	758 Junan Lane
3rd row	758 Junan Lane
4th row	758 Junan Lane
5th row	76 Kermanshah Manor

Value	Count	Frequency (%)
parkway	11137	3.9%
manor	9908	3.4%
avenue	8963	3.1%
way	8854	3.1%
lane	8745	3.0%
street	8622	3.0%
place	8225	2.8%
loop	8071	2.8%
boulevard	7812	2.7%
drive	7643	2.6%
Other values (957)	201223	69.6%

Most occurring characters

Value	Count	Frequency (%)
	201223	11.8%
a	178952	10.5%
e	110192	6.4%
o	87025	5.1%
r	83504	4.9%
n	82148	4.8%
1	67756	4.0%
i	51591	3.0%
l	51231	3.0%
u	49041	2.9%
Other values (56)	749586	43.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1004855	58.7%
Decimal Number	299535	17.5%
Space Separator	201223	11.8%
Uppercase Letter	198759	11.6%
Dash Punctuation	3499	0.2%
Open Punctuation	2189	0.1%
Close Punctuation	2189	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	178952	17.8%
e	110192	11.0%
o	87025	8.7%
r	83504	8.3%
n	82148	8.2%
i	51591	5.1%
l	51231	5.1%
u	49041	4.9%
t	41214	4.1%
y	29485	2.9%
Other values (16)	240472	23.9%

Uppercase Letter

Value	Count	Frequency (%)
P	26620	13.4%
L	22014	11.1%
S	21827	11.0%
B	18491	9.3%
A	17384	8.7%
M	15293	7.7%
D	10480	5.3%
W	9464	4.8%
C	9140	4.6%
T	6523	3.3%
Other values (16)	41523	20.9%

Decimal Number

Value	Count	Frequency (%)
1	67756	22.6%
6	29479	9.8%
4	29025	9.7%
9	28334	9.5%
7	26587	8.9%
8	26234	8.8%
5	24905	8.3%
2	24523	8.2%
3	23339	7.8%
0	19353	6.5%

Space Separator

Value	Count	Frequency (%)
	201223	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3499	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2189	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2189	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1203614	70.3%
Common	508635	29.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	178952	14.9%
e	110192	9.2%
o	87025	7.2%
r	83504	6.9%
n	82148	6.8%
i	51591	4.3%
l	51231	4.3%
u	49041	4.1%
t	41214	3.4%
y	29485	2.4%
Other values (42)	439231	36.5%

Common

Value	Count	Frequency (%)
	201223	39.6%
1	67756	13.3%
6	29479	5.8%
4	29025	5.7%
9	28334	5.6%
7	26587	5.2%
8	26234	5.2%
5	24905	4.9%
2	24523	4.8%
3	23339	4.6%
Other values (4)	27230	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1712249	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	201223	11.8%
a	178952	10.5%
e	110192	6.4%
o	87025	5.1%
r	83504	4.9%
n	82148	4.8%
1	67756	4.0%
i	51591	3.0%
l	51231	3.0%
u	49041	2.9%
Other values (56)	749586	43.8%

address2
Unsupported

Missing Rejected Unsupported

Missing	87980
Missing (%)	100.0%
Memory size	687.5 KiB

district
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

	87980

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	87980
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	87980	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Most occurring characters

Value	Count	Frequency (%)
	87980	100.0%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	87980	100.0%

Most frequent character per category

Space Separator

Value	Count	Frequency (%)
	87980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	87980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	87980	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	87980	100.0%

postal_code
Real number (ℝ)

Distinct	596
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50328.658

Minimum	3
Maximum	99865
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	3
5-th percentile	4855
Q1	25220
median	50805
Q3	74750
95-th percentile	95509
Maximum	99865
Range	99862
Interquartile range (IQR)	49530

Descriptive statistics

Standard deviation	28834.472
Coefficient of variation (CV)	0.57292353
Kurtosis	-1.1636062
Mean	50328.658
Median Absolute Deviation (MAD)	24669
Skewness	-0.018899509
Sum	4.4279153 × 10⁹
Variance	8.3142679 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52137	299	0.3%
9668	284	0.3%
92150	272	0.3%
22474	270	0.3%
31342	251	0.3%
89459	244	0.3%
30861	239	0.3%
72394	233	0.3%
18727	233	0.3%
65750	223	0.3%
Other values (586)	85432	97.1%

Value	Count	Frequency (%)
3	122	0.1%
400	138	0.2%
504	130	0.1%
841	108	0.1%
943	133	0.2%
966	118	0.1%
1027	132	0.2%
1079	122	0.1%
1195	146	0.2%
1545	190	0.2%

Value	Count	Frequency (%)
99865	126	0.1%
99780	165	0.2%
99552	156	0.2%
99457	168	0.2%
99405	178	0.2%
99124	124	0.1%
98889	141	0.2%
98883	157	0.2%
98775	121	0.1%
98573	157	0.2%

city_id
Real number (ℝ)

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	301.38936

Minimum	1
Maximum	600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	31
Q1	148
median	304
Q3	452
95-th percentile	569
Maximum	600
Range	599
Interquartile range (IQR)	304

Descriptive statistics

Standard deviation	173.50817
Coefficient of variation (CV)	0.57569442
Kurtosis	-1.2104272
Mean	301.38936
Median Absolute Deviation (MAD)	152
Skewness	-0.016232752
Sum	26516236
Variance	30105.086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	275	0.3%
442	272	0.3%
312	271	0.3%
101	251	0.3%
109	244	0.3%
340	239	0.3%
108	233	0.3%
527	233	0.3%
474	223	0.3%
64	221	0.3%
Other values (587)	85518	97.2%

Value	Count	Frequency (%)
1	156	0.2%
2	124	0.1%
3	177	0.2%
4	160	0.2%
5	131	0.1%
6	123	0.1%
7	178	0.2%
8	136	0.2%
9	164	0.2%
10	157	0.2%

Value	Count	Frequency (%)
600	131	0.1%
599	171	0.2%
598	157	0.2%
597	138	0.2%
596	153	0.2%
595	81	0.1%
594	123	0.1%
593	144	0.2%
592	139	0.2%
591	137	0.2%

city
Text

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	26
Median length	21
Mean length	8.3905433
Min length	2

Characters and Unicode

Total characters	738200
Distinct characters	57
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	guas Lindas de Gois
2nd row	guas Lindas de Gois
3rd row	guas Lindas de Gois
4th row	guas Lindas de Gois
5th row	Qomsheh

Value	Count	Frequency (%)
de	1920	1.8%
san	946	0.9%
la	727	0.7%
del	581	0.5%
santa	578	0.5%
el	433	0.4%
hill	411	0.4%
santiago	395	0.4%
plata	353	0.3%
felipe	344	0.3%
Other values (673)	100656	93.8%

Most occurring characters

Value	Count	Frequency (%)
a	109594	14.8%
n	52055	7.1%
o	47619	6.5%
i	46517	6.3%
e	42688	5.8%
r	38393	5.2%
u	34216	4.6%
l	30362	4.1%
s	24830	3.4%
t	24653	3.3%
Other values (47)	287273	38.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	605191	82.0%
Uppercase Letter	106585	14.4%
Space Separator	19364	2.6%
Dash Punctuation	3852	0.5%
Close Punctuation	1522	0.2%
Open Punctuation	1522	0.2%
Other Punctuation	164	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	109594	18.1%
n	52055	8.6%
o	47619	7.9%
i	46517	7.7%
e	42688	7.1%
r	38393	6.3%
u	34216	5.7%
l	30362	5.0%
s	24830	4.1%
t	24653	4.1%
Other values (16)	154264	25.5%

Uppercase Letter

Value	Count	Frequency (%)
S	13282	12.5%
B	9638	9.0%
A	7252	6.8%
C	7249	6.8%
P	6320	5.9%
T	6224	5.8%
K	5920	5.6%
M	5791	5.4%
L	5210	4.9%
H	4334	4.1%
Other values (16)	35365	33.2%

Space Separator

Value	Count	Frequency (%)
	19364	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3852	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1522	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1522	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	164	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	711776	96.4%
Common	26424	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	109594	15.4%
n	52055	7.3%
o	47619	6.7%
i	46517	6.5%
e	42688	6.0%
r	38393	5.4%
u	34216	4.8%
l	30362	4.3%
s	24830	3.5%
t	24653	3.5%
Other values (42)	260849	36.6%

Common

Value	Count	Frequency (%)
	19364	73.3%
-	3852	14.6%
)	1522	5.8%
(	1522	5.8%
/	164	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	738200	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	109594	14.8%
n	52055	7.1%
o	47619	6.5%
i	46517	6.3%
e	42688	5.8%
r	38393	5.2%
u	34216	4.6%
l	30362	4.1%
s	24830	3.4%
t	24653	3.3%
Other values (47)	287273	38.9%

country_id
Real number (ℝ)

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.862946

Minimum	1
Maximum	109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	29
median	50
Q3	80
95-th percentile	103
Maximum	109
Range	108
Interquartile range (IQR)	51

Descriptive statistics

Standard deviation	30.063209
Coefficient of variation (CV)	0.52869595
Kurtosis	-1.1599807
Mean	56.862946
Median Absolute Deviation (MAD)	27
Skewness	0.056106303
Sum	5002802
Variance	903.79656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	8637	9.8%
23	7724	8.8%
103	5428	6.2%
50	4565	5.2%
60	4493	5.1%
15	4042	4.6%
80	3895	4.4%
75	3160	3.6%
97	2094	2.4%
45	2014	2.3%
Other values (98)	41928	47.7%

Value	Count	Frequency (%)
1	109	0.1%
2	457	0.5%
3	111	0.1%
4	301	0.3%
5	195	0.2%
6	1884	2.1%
7	150	0.2%
9	403	0.5%
10	302	0.3%
11	134	0.2%

Value	Count	Frequency (%)
109	174	0.2%
108	328	0.4%
107	628	0.7%
106	190	0.2%
105	908	1.0%
104	963	1.1%
103	5428	6.2%
102	1210	1.4%
101	476	0.5%
100	823	0.9%

country
Text

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Length

Max length	37
Median length	29
Mean length	8.1365765
Min length	4

Characters and Unicode

Total characters	715856
Distinct characters	54
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brazil
2nd row	Brazil
3rd row	Brazil
4th row	Brazil
5th row	Iran

Value	Count	Frequency (%)
india	8637	8.0%
china	7724	7.2%
united	7114	6.6%
states	5428	5.0%
japan	4565	4.2%
mexico	4493	4.2%
brazil	4042	3.8%
russian	3895	3.6%
federation	3895	3.6%
philippines	3160	2.9%
Other values (122)	54818	50.9%

Most occurring characters

Value	Count	Frequency (%)
a	95628	13.4%
i	80527	11.2%
n	72671	10.2%
e	58230	8.1%
t	35504	5.0%
r	31038	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20000	2.8%
Other values (44)	240530	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	587642	82.1%
Uppercase Letter	107199	15.0%
Space Separator	19791	2.8%
Other Punctuation	818	0.1%
Open Punctuation	203	< 0.1%
Close Punctuation	203	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	95628	16.3%
i	80527	13.7%
n	72671	12.4%
e	58230	9.9%
t	35504	6.0%
r	31038	5.3%
d	30203	5.1%
o	26432	4.5%
s	25093	4.3%
l	20000	3.4%
Other values (16)	112316	19.1%

Uppercase Letter

Value	Count	Frequency (%)
I	13962	13.0%
S	11266	10.5%
C	11076	10.3%
U	8127	7.6%
A	6693	6.2%
P	6557	6.1%
M	6538	6.1%
B	5804	5.4%
R	5699	5.3%
T	5497	5.1%
Other values (13)	25980	24.2%

Other Punctuation

Value	Count	Frequency (%)
,	438	53.5%
.	380	46.5%

Space Separator

Value	Count	Frequency (%)
	19791	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	203	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	203	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	694841	97.1%
Common	21015	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	95628	13.8%
i	80527	11.6%
n	72671	10.5%
e	58230	8.4%
t	35504	5.1%
r	31038	4.5%
d	30203	4.3%
o	26432	3.8%
s	25093	3.6%
l	20000	2.9%
Other values (39)	219515	31.6%

Common

Value	Count	Frequency (%)
	19791	94.2%
,	438	2.1%
.	380	1.8%
(	203	1.0%
)	203	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	715856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	95628	13.4%
i	80527	11.2%
n	72671	10.2%
e	58230	8.1%
t	35504	5.0%
r	31038	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20000	2.8%
Other values (44)	240530	33.6%

category_id
Real number (ℝ)

High correlation

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3390657

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	8
Q3	13
95-th percentile	16
Maximum	16
Range	15
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	4.7002421
Coefficient of variation (CV)	0.56364133
Kurtosis	-1.2488883
Mean	8.3390657
Median Absolute Deviation (MAD)	4
Skewness	0.039042849
Sum	733671
Variance	22.092276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
15	6936	7.9%
2	6600	7.5%
1	6307	7.2%
6	6188	7.0%
7	5929	6.7%
14	5743	6.5%
8	5615	6.4%
9	5559	6.3%
3	5510	6.3%
13	5192	5.9%
Other values (6)	28401	32.3%

Value	Count	Frequency (%)
1	6307	7.2%
2	6600	7.5%
3	5510	6.3%
4	5088	5.8%
5	4662	5.3%
6	6188	7.0%
7	5929	6.7%
8	5615	6.4%
9	5559	6.3%
10	4552	5.2%

Value	Count	Frequency (%)
16	4668	5.3%
15	6936	7.9%
14	5743	6.5%
13	5192	5.9%
12	4503	5.1%
11	4928	5.6%
10	4552	5.2%
9	5559	6.3%
8	5615	6.4%
7	5929	6.7%

category
Categorical

High correlation

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

Sports	6936
Animation	6600
Action	6307
Documentary	6188
Drama	5929
Other values (11)	56020

Length

Max length	11
Median length	9
Mean length	6.5334735
Min length	3

Characters and Unicode

Total characters	574815
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Family
2nd row	Family
3rd row	Family
4th row	Family
5th row	Music

Common Values

Value	Count	Frequency (%)
Sports	6936	7.9%
Animation	6600	7.5%
Action	6307	7.2%
Documentary	6188	7.0%
Drama	5929	6.7%
Sci-Fi	5743	6.5%
Family	5615	6.4%
Foreign	5559	6.3%
Children	5510	6.3%
New	5192	5.9%
Other values (6)	28401	32.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sports	6936	7.9%
animation	6600	7.5%
action	6307	7.2%
documentary	6188	7.0%
drama	5929	6.7%
sci-fi	5743	6.5%
family	5615	6.4%
foreign	5559	6.3%
children	5510	6.3%
new	5192	5.9%
Other values (6)	28401	32.3%

Most occurring characters

Value	Count	Frequency (%)
i	57268	10.0%
r	49574	8.6%
o	46108	8.0%
a	44569	7.8%
n	36764	6.4%
e	36331	6.3%
m	33546	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185540	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	475349	82.7%
Uppercase Letter	93723	16.3%
Dash Punctuation	5743	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	57268	12.0%
r	49574	10.4%
o	46108	9.7%
a	44569	9.4%
n	36764	7.7%
e	36331	7.6%
m	33546	7.1%
s	31255	6.6%
c	27829	5.9%
t	26031	5.5%
Other values (9)	86074	18.1%

Uppercase Letter

Value	Count	Frequency (%)
F	16917	18.0%
C	15260	16.3%
A	12907	13.8%
S	12679	13.5%
D	12117	12.9%
N	5192	5.5%
H	4928	5.3%
T	4668	5.0%
G	4552	4.9%
M	4503	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	5743	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	569072	99.0%
Common	5743	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	57268	10.1%
r	49574	8.7%
o	46108	8.1%
a	44569	7.8%
n	36764	6.5%
e	36331	6.4%
m	33546	5.9%
s	31255	5.5%
c	27829	4.9%
t	26031	4.6%
Other values (19)	179797	31.6%

Common

Value	Count	Frequency (%)
-	5743	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	574815	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	57268	10.0%
r	49574	8.6%
o	46108	8.0%
a	44569	7.8%
n	36764	6.4%
e	36331	6.3%
m	33546	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185540	32.3%

language
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.5 KiB

English	87980

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	615860
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	English
2nd row	English
3rd row	English
4th row	English
5th row	English

Common Values

Value	Count	Frequency (%)
English	87980	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
english	87980	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	87980	14.3%
n	87980	14.3%
g	87980	14.3%
l	87980	14.3%
i	87980	14.3%
s	87980	14.3%
h	87980	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	527880	85.7%
Uppercase Letter	87980	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	87980	16.7%
g	87980	16.7%
l	87980	16.7%
i	87980	16.7%
s	87980	16.7%
h	87980	16.7%

Uppercase Letter

Value	Count	Frequency (%)
E	87980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	615860	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	87980	14.3%
n	87980	14.3%
g	87980	14.3%
l	87980	14.3%
i	87980	14.3%
s	87980	14.3%
h	87980	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	615860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	87980	14.3%
n	87980	14.3%
g	87980	14.3%
l	87980	14.3%
i	87980	14.3%
s	87980	14.3%
h	87980	14.3%

film_category_id
Real number (ℝ)

High correlation

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	502.11853

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	48
Q1	255
median	496
Q3	752
95-th percentile	952
Maximum	1000
Range	999
Interquartile range (IQR)	497

Descriptive statistics

Standard deviation	288.32439
Coefficient of variation (CV)	0.57421581
Kurtosis	-1.1870348
Mean	502.11853
Median Absolute Deviation (MAD)	247
Skewness	-0.010455299
Sum	44176388
Variance	83130.956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
489	288	0.3%
892	276	0.3%
880	275	0.3%
249	273	0.3%
649	264	0.3%
301	261	0.3%
764	252	0.3%
418	248	0.3%
369	248	0.3%
414	240	0.3%
Other values (945)	85355	97.0%

Value	Count	Frequency (%)
1	230	0.3%
2	28	< 0.1%
3	60	0.1%
4	115	0.1%
5	60	0.1%
6	147	0.2%
7	75	0.1%
8	72	0.1%
9	108	0.1%
10	184	0.2%

Value	Count	Frequency (%)
1000	93	0.1%
999	85	0.1%
998	54	0.1%
997	30	< 0.1%
996	35	< 0.1%
995	23	< 0.1%
994	78	0.1%
993	180	0.2%
992	56	0.1%
991	64	0.1%

film_actor_id
Real number (ℝ)

High correlation

Distinct	200
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.9536

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	52
median	102
Q3	149
95-th percentile	191
Maximum	200
Range	199
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	56.900302
Coefficient of variation (CV)	0.56362824
Kurtosis	-1.1747542
Mean	100.9536
Median Absolute Deviation (MAD)	48
Skewness	0.0020452118
Sum	8881898
Variance	3237.6443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	753	0.9%
181	678	0.8%
198	674	0.8%
144	654	0.7%
102	640	0.7%
60	612	0.7%
150	611	0.7%
37	605	0.7%
23	604	0.7%
90	599	0.7%
Other values (190)	81550	92.7%

Value	Count	Frequency (%)
1	305	0.3%
2	387	0.4%
3	311	0.4%
4	274	0.3%
5	496	0.6%
6	279	0.3%
7	479	0.5%
8	317	0.4%
9	381	0.4%
10	362	0.4%

Value	Count	Frequency (%)
200	346	0.4%
199	255	0.3%
198	674	0.8%
197	553	0.6%
196	450	0.5%
195	450	0.5%
194	380	0.4%
193	444	0.5%
192	458	0.5%
191	523	0.6%

Interactions

Correlations

	active	actor_id	address_id	amount	category	category_id	city_id	country_id	customer_id	film_actor_id	film_category_id	film_id	inventory_id	length	manager_staff_id	payment_id	postal_code	rating	rental_duration	rental_id	rental_rate	replacement_cost	staff_fn	staff_id	staff_ln	store_id
active	1.000	0.000	0.085	0.027	0.032	0.021	0.109	0.094	0.092	0.000	0.023	0.023	0.021	0.029	0.003	0.092	0.138	0.014	0.012	0.021	0.007	0.018	0.003	0.003	0.003	0.003
actor_id	0.000	1.000	0.001	-0.007	0.056	0.011	0.002	0.001	0.001	1.000	0.015	0.015	0.015	0.015	0.000	0.001	0.004	0.043	0.041	-0.003	0.042	-0.001	0.000	0.000	0.000	0.000
address_id	0.085	0.001	1.000	0.014	0.032	0.024	0.042	-0.042	1.000	0.001	-0.003	-0.003	-0.003	-0.013	0.075	1.000	-0.043	0.019	0.028	-0.004	0.027	-0.022	0.075	0.075	0.075	0.075
amount	0.027	-0.007	0.014	1.000	0.065	0.087	0.001	0.013	0.014	-0.007	0.027	0.027	0.027	0.003	0.016	0.014	-0.012	0.034	0.171	0.002	0.706	-0.030	0.016	0.016	0.016	0.016
category	0.032	0.056	0.032	0.065	1.000	1.000	0.033	0.029	0.032	0.056	0.139	0.139	0.138	0.149	0.030	0.031	0.029	0.156	0.161	0.024	0.145	0.141	0.030	0.030	0.030	0.030
category_id	0.021	0.011	0.024	0.087	1.000	1.000	0.001	-0.003	0.024	0.011	-0.027	-0.027	-0.027	0.093	0.019	0.024	-0.005	0.113	0.104	0.008	0.116	-0.033	0.019	0.019	0.019	0.019
city_id	0.109	0.002	0.042	0.001	0.033	0.001	1.000	-0.059	0.042	0.002	0.009	0.009	0.009	-0.002	0.105	0.042	-0.071	0.020	0.021	-0.005	0.026	-0.001	0.105	0.105	0.105	0.105
country_id	0.094	0.001	-0.042	0.013	0.029	-0.003	-0.059	1.000	-0.042	0.001	0.017	0.017	0.017	0.012	0.102	-0.042	0.001	0.023	0.021	-0.005	0.020	0.004	0.102	0.102	0.102	0.102
customer_id	0.092	0.001	1.000	0.014	0.032	0.024	0.042	-0.042	1.000	0.001	-0.003	-0.003	-0.003	-0.013	0.074	1.000	-0.043	0.018	0.028	-0.004	0.027	-0.022	0.074	0.074	0.074	0.074
film_actor_id	0.000	1.000	0.001	-0.007	0.056	0.011	0.002	0.001	0.001	1.000	0.015	0.015	0.015	0.015	0.000	0.001	0.004	0.043	0.041	-0.003	0.042	-0.001	0.000	0.000	0.000	0.000
film_category_id	0.023	0.015	-0.003	0.027	0.139	-0.027	0.009	0.017	-0.003	0.015	1.000	1.000	1.000	0.054	0.034	-0.003	-0.009	0.120	0.113	-0.002	0.112	-0.040	0.034	0.034	0.034	0.034
film_id	0.023	0.015	-0.003	0.027	0.139	-0.027	0.009	0.017	-0.003	0.015	1.000	1.000	1.000	0.054	0.034	-0.003	-0.009	0.120	0.113	-0.002	0.112	-0.040	0.034	0.034	0.034	0.034
inventory_id	0.021	0.015	-0.003	0.027	0.138	-0.027	0.009	0.017	-0.003	0.015	1.000	1.000	1.000	0.054	0.032	-0.003	-0.009	0.118	0.112	-0.002	0.116	-0.040	0.032	0.032	0.032	0.032
length	0.029	0.015	-0.013	0.003	0.149	0.093	-0.002	0.012	-0.013	0.015	0.054	0.054	0.054	1.000	0.016	-0.013	-0.004	0.101	0.087	0.001	0.105	0.014	0.016	0.016	0.016	0.016
manager_staff_id	0.003	0.000	0.075	0.016	0.030	0.019	0.105	0.102	0.074	0.000	0.034	0.034	0.032	0.016	1.000	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
payment_id	0.092	0.001	1.000	0.014	0.031	0.024	0.042	-0.042	1.000	0.001	-0.003	-0.003	-0.003	-0.013	0.072	1.000	-0.043	0.017	0.028	-0.002	0.025	-0.022	0.072	0.072	0.072	0.072
postal_code	0.138	0.004	-0.043	-0.012	0.029	-0.005	-0.071	0.001	-0.043	0.004	-0.009	-0.009	-0.009	-0.004	0.090	-0.043	1.000	0.017	0.015	0.006	0.026	-0.001	0.090	0.090	0.090	0.090
rating	0.014	0.043	0.019	0.034	0.156	0.113	0.020	0.023	0.018	0.043	0.120	0.120	0.118	0.101	0.015	0.017	0.017	1.000	0.096	0.020	0.038	0.112	0.015	0.015	0.015	0.015
rental_duration	0.012	0.041	0.028	0.171	0.161	0.104	0.021	0.021	0.028	0.041	0.113	0.113	0.112	0.087	0.007	0.028	0.015	0.096	1.000	0.021	0.072	0.083	0.007	0.007	0.007	0.007
rental_id	0.021	-0.003	-0.004	0.002	0.024	0.008	-0.005	-0.005	-0.004	-0.003	-0.002	-0.002	-0.002	0.001	0.028	-0.002	0.006	0.020	0.021	1.000	0.024	0.004	0.028	0.028	0.028	0.028
rental_rate	0.007	0.042	0.027	0.706	0.145	0.116	0.026	0.020	0.027	0.042	0.112	0.112	0.116	0.105	0.000	0.025	0.026	0.038	0.072	0.024	1.000	0.109	0.000	0.000	0.000	0.000
replacement_cost	0.018	-0.001	-0.022	-0.030	0.141	-0.033	-0.001	0.004	-0.022	-0.001	-0.040	-0.040	-0.040	0.014	0.027	-0.022	-0.001	0.112	0.083	0.004	0.109	1.000	0.027	0.027	0.027	0.027
staff_fn	0.003	0.000	0.075	0.016	0.030	0.019	0.105	0.102	0.074	0.000	0.034	0.034	0.032	0.016	1.000	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_id	0.003	0.000	0.075	0.016	0.030	0.019	0.105	0.102	0.074	0.000	0.034	0.034	0.032	0.016	1.000	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_ln	0.003	0.000	0.075	0.016	0.030	0.019	0.105	0.102	0.074	0.000	0.034	0.034	0.032	0.016	1.000	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
store_id	0.003	0.000	0.075	0.016	0.030	0.019	0.105	0.102	0.074	0.000	0.034	0.034	0.032	0.016	1.000	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	film_id	title	description	release_year	language_id	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	manager_staff_id	staff_id	staff_fn	staff_ln	address_id	address	address2	postal_code	city_id	city	country_id	country	category_id	category	language	film_category_id	film_actor_id
0	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	2006	1	7	2.99	148	21.99	G	16	FRED	COSTNER	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	1	Mike	Hillyer	134	758 Junan Lane	NaN	82639	190	guas Lindas de Gois	15	Brazil	8	Family	English	80	16
1	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	2006	1	7	2.99	148	21.99	G	173	ALAN	DREYFUSS	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	1	Mike	Hillyer	134	758 Junan Lane	NaN	82639	190	guas Lindas de Gois	15	Brazil	8	Family	English	80	173
2	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	2006	1	7	2.99	148	21.99	G	193	BURT	TEMPLE	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	1	Mike	Hillyer	134	758 Junan Lane	NaN	82639	190	guas Lindas de Gois	15	Brazil	8	Family	English	80	193
3	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	2006	1	7	2.99	148	21.99	G	200	THORA	TEMPLE	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	1	Mike	Hillyer	134	758 Junan Lane	NaN	82639	190	guas Lindas de Gois	15	Brazil	8	Family	English	80	200
4	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	2006	1	7	2.99	126	16.99	R	42	TOM	MIRANDA	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	1	Mike	Hillyer	464	76 Kermanshah Manor	NaN	23343	423	Qomsheh	46	Iran	12	Music	English	333	42
5	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	2006	1	7	2.99	126	16.99	R	103	MATTHEW	LEIGH	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	1	Mike	Hillyer	464	76 Kermanshah Manor	NaN	23343	423	Qomsheh	46	Iran	12	Music	English	333	103
6	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	2006	1	7	2.99	126	16.99	R	105	SIDNEY	CROWE	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	1	Mike	Hillyer	464	76 Kermanshah Manor	NaN	23343	423	Qomsheh	46	Iran	12	Music	English	333	105
7	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	2006	1	7	2.99	126	16.99	R	127	KEVIN	GARLAND	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	1	Mike	Hillyer	464	76 Kermanshah Manor	NaN	23343	423	Qomsheh	46	Iran	12	Music	English	333	127
8	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	2006	1	7	2.99	126	16.99	R	147	FAY	WINSLET	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	1	Mike	Hillyer	464	76 Kermanshah Manor	NaN	23343	423	Qomsheh	46	Iran	12	Music	English	333	147
9	373	GRADUATE LORD	A Lacklusture Epistle of a Girl And a A Shark who must Meet a Mad Scientist in Ancient China	2006	1	7	2.99	156	14.99	G	139	EWAN	GOODING	408	MANUEL	MURRELL	MANUEL.MURRELL@sakilacustomer.org	1	3	2005-05-24 23:03:39.000	2005-06-01 22:12:39.000	11032	3.99	2005-05-24 23:03:39.000	1711	1	1	1	Mike	Hillyer	413	692 Amroha Drive	NaN	35575	230	Jaffna	88	Sri Lanka	3	Children	English	373	139

	film_id	title	description	release_year	language_id	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	manager_staff_id	staff_id	staff_fn	staff_ln	address_id	address	address2	postal_code	city_id	city	country_id	country	category_id	category	language	film_category_id	film_actor_id
87970	452	ILLUSION AMELIE	A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft	2006	1	4	0.99	122	15.99	R	133	RICHARD	PENN	114	GRACE	ELLIS	GRACE.ELLIS@sakilacustomer.org	1	16047	2005-08-23 22:42:48.000	2005-08-25 02:48:48.000	3089	0.99	2005-08-23 22:42:48.000	2088	2	2	2	Jon	Stephens	118	442 Rae Bareli Place	NaN	24321	148	Duisburg	38	Germany	9	Foreign	English	452	133
87971	452	ILLUSION AMELIE	A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft	2006	1	4	0.99	122	15.99	R	184	HUMPHREY	GARLAND	114	GRACE	ELLIS	GRACE.ELLIS@sakilacustomer.org	1	16047	2005-08-23 22:42:48.000	2005-08-25 02:48:48.000	3089	0.99	2005-08-23 22:42:48.000	2088	2	2	2	Jon	Stephens	118	442 Rae Bareli Place	NaN	24321	148	Duisburg	38	Germany	9	Foreign	English	452	184
87972	439	HUNCHBACK IMPOSSIBLE	A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan	2006	1	4	4.99	151	28.99	PG-13	106	GROUCHO	DUNST	103	GLADYS	HAMILTON	GLADYS.HAMILTON@sakilacustomer.org	1	16048	2005-08-23 22:43:07.000	2005-08-31 21:33:07.000	2799	8.99	2005-08-23 22:43:07.000	2019	1	1	1	Mike	Hillyer	107	1177 Jelets Way	NaN	3305	220	Ilorin	69	Nigeria	7	Drama	English	439	106
87973	439	HUNCHBACK IMPOSSIBLE	A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan	2006	1	4	4.99	151	28.99	PG-13	175	WILLIAM	HACKMAN	103	GLADYS	HAMILTON	GLADYS.HAMILTON@sakilacustomer.org	1	16048	2005-08-23 22:43:07.000	2005-08-31 21:33:07.000	2799	8.99	2005-08-23 22:43:07.000	2019	1	1	1	Mike	Hillyer	107	1177 Jelets Way	NaN	3305	220	Ilorin	69	Nigeria	7	Drama	English	439	175
87974	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	24	CAMERON	STREEP	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	24
87975	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	31	SISSY	SOBIESKI	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	31
87976	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	32	TIM	HACKMAN	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	32
87977	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	61	CHRISTIAN	NEESON	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	61
87978	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	103	MATTHEW	LEIGH	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	103
87979	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	2006	1	4	0.99	105	25.99	G	106	GROUCHO	DUNST	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	NaN	8816	278	Korolev	80	Russian Federation	7	Drama	English	585	106

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block